{
  "job": {
    "setting": {
      "speed": {
        "channel": 1
      },
      "errorLimit": {
        "record": 0,
        "percentage": 0.02
      }
    },
    "content": [
      {
        "reader": {
          "name": "mysqlreader",
          "parameter": {
            "username": "root",
            "password": "123456",
            "column": [
              "`comment_id`",
              "`product_id`",
              "`user_id`",
              "`order_id`",
              "`content`",
              "`score`",
              "`has_pic`",
              "`comment_time`",
              "`reply_content`"
            ],
            "where": "1=1",
            "splitPk": "",
            "connection": [
              {
                "table": [
                  "comment"
                ],
                "jdbcUrl": [
                  "jdbc:mysql://node101:3306/jtp_gd07_warehouse"
                ]
              }
            ]
          }
        },
        "writer": {
          "name": "hdfswriter",
          "parameter": {
            "defaultFS": "hdfs://node101:8020",
            "fileType": "orc",
            "path": "/user/hive/warehouse/jtp_gd07_warehouse/ods_tb_comment",
            "fileName": "comment",
            "writeMode": "truncate",
            "fieldDelimiter": "\t",
            "column": [
              {
                "name": "comment_id",
                "type": "string"
              },
              {
                "name": "product_id",
                "type": "string"
              },
              {
                "name": "user_id",
                "type": "string"
              },
              {
                "name": "order_id",
                "type": "string"
              },
              {
                "name": "content",
                "type": "string"
              },
              {
                "name": "score",
                "type": "int"
              },
              {
                "name": "has_pic",
                "type": "int"
              },
              {
                "name": "comment_time",
                "type": "timestamp"
              },
              {
                "name": "reply_content",
                "type": "string"
              }
            ]
          }
        }
      }
    ]
  }
}